UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1bYePi7XoGgr+tRt9KRrGsn434WPuaUAaGjyoZA2pw8='
WHERE
key_id = '0270c41a3f955f39d966c578f40fde69765ca98da0b52f5e01cd2799262c7e33'
AND (
token = '1bYePi7XoGgr+tRt9KRrGsn434WPuaUAaGjyoZA2pw8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)