UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gEu21LbHOkxeWBlLWrEifnmPWmkvpWvy1f5FD9e5cSk='
WHERE
key_id = 'b3d9816b00c2879eecf2a8ce91043b12712ddeb4f140f658f00f9ce84b09a1c8'
AND (
token = 'gEu21LbHOkxeWBlLWrEifnmPWmkvpWvy1f5FD9e5cSk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)