UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7DDBZNdVvT8K6y2LFeIMRq8YEVjTMmiba36lcyas7B8='
WHERE
key_id = 'bc101ec9a0a62348e0b1e7507eef99ae76ead848b2cb4b1a32124768e7160fc6'
AND (
token = '7DDBZNdVvT8K6y2LFeIMRq8YEVjTMmiba36lcyas7B8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)