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