UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8JZc/CEaG0er8vAR16AY41qjWghupdA2GxTiWHgw6vA='
WHERE
key_id = '80f9149914b4b3fb8f9b568092ac8d25ad89a35f2b21f6bd6b44302b65722f2e'
AND (
token = '8JZc/CEaG0er8vAR16AY41qjWghupdA2GxTiWHgw6vA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)