UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HpaEeXoVKAIwHai0flxv+KWV/KntWZAI0k+3q1CZnpw='
WHERE
key_id = 'a284d1837d8e66c30dc793420eedfff21e52c4631a93c3199b92b435949cdc01'
AND (
token = 'HpaEeXoVKAIwHai0flxv+KWV/KntWZAI0k+3q1CZnpw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)