UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qmA22vPnhMFz2+nvSmPndNFx/KljeM8lgJXjcWzgOro='
WHERE
key_id = '471dd873eb470fd2474681b22aa075e833eec3cc66058a67133b9dba5021ffe2'
AND (
token = 'qmA22vPnhMFz2+nvSmPndNFx/KljeM8lgJXjcWzgOro='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)