UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RprKO/8BlgWoLJ02gOdJxs+gotRQhznnD+DKVILTT/Y='
WHERE
key_id = 'a88c6aea95488951f6d91ae68f6ca4459a45b123017453b2c10edd7111916154'
AND (
token = 'RprKO/8BlgWoLJ02gOdJxs+gotRQhznnD+DKVILTT/Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)