UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'I4beEPgLlwm8DoIDTVNTJZCu+boi/2Ekyz/s+Ez63Do='
WHERE
key_id = '3a22be777276a436eb78f225dc1957e11c797c16ccc4e943700e6d6f4457f1ee'
AND (
token = 'I4beEPgLlwm8DoIDTVNTJZCu+boi/2Ekyz/s+Ez63Do='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)