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