UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kbFHY8YWTkGWawm78tX0L12sh7fvfrfgObmiJtgj6eo='
WHERE
key_id = 'dc7f1a24f5acacc4b8305377de94abff1aed5b7c8303105eec192413f8b883a1'
AND (
token = 'kbFHY8YWTkGWawm78tX0L12sh7fvfrfgObmiJtgj6eo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)