UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a8YbPHnNrSE3Vpz4CQK6JPZyM7+oyaW6a4LORY8VDPA='
WHERE
key_id = '0b08fc7bea035de639575bbfa32185a11f65d6ff5a5eb3bfaba83bc35216ccb9'
AND (
token = 'a8YbPHnNrSE3Vpz4CQK6JPZyM7+oyaW6a4LORY8VDPA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)