UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NaSnuioKZ4zSZ/LIOYa6uPE3CwnG1k7z4pP9tkM3B5Q='
WHERE
key_id = '9b96a4e0536915f0aa724013607b103969bc3cb9b004bf962dcc5dc66278cea7'
AND (
token = 'NaSnuioKZ4zSZ/LIOYa6uPE3CwnG1k7z4pP9tkM3B5Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)