UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jn3hSguZEuDZqaeMB7yGjwXKcTidGGSj0oYnwHYLCtI='
WHERE
key_id = 'e114309587cd0708e58101c96a0ce5872bf9bb9e4cf2096b592723abe80ac35f'
AND (
token = 'jn3hSguZEuDZqaeMB7yGjwXKcTidGGSj0oYnwHYLCtI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)