UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uIIgMNKRQpSa3HChWUeY4zY5ItuS6SrVL+3UDw9MfpE='
WHERE
key_id = '9e22ec9b5cb5c3163f381221aa69e183d2445f933a33428c5050b04785df2a4e'
AND (
token = 'uIIgMNKRQpSa3HChWUeY4zY5ItuS6SrVL+3UDw9MfpE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)