UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D6AQjHUAVZ0YItcw0pQlzwEcq7oTYQYDatzRulBf+BQ='
WHERE
key_id = '4ea93deea597c8bbb85bafa132965a458bb8aabf0859287822b23dfef2888972'
AND (
token = 'D6AQjHUAVZ0YItcw0pQlzwEcq7oTYQYDatzRulBf+BQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)