UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x9gGrynTQN231QsEP2sNqYYVKzNyD4PBNFXmnIjvjJM='
WHERE
key_id = '0ca01658614193994c541f19ec5a356a0fc36940ceb9e562307ab01fb20e04dc'
AND (
token = 'x9gGrynTQN231QsEP2sNqYYVKzNyD4PBNFXmnIjvjJM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)