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