UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ucKQai9RGEPM8yCcQIN0u5EriTgo+n9SM128bC/nQmU='
WHERE
key_id = '471fb8037908fb1e09192bc6f6417382445b07c54e79ace05f476de4014fd79f'
AND (
token = 'ucKQai9RGEPM8yCcQIN0u5EriTgo+n9SM128bC/nQmU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)