UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZQk8ScOweriWIpNFB9/QrTTld2hCgSBmRFd/0zcM2cI='
WHERE
key_id = 'c7d7a41bf326ec4aef87482532f9398c77fe7f3d0cbd972640ab7dd08a36f24f'
AND (
token = 'ZQk8ScOweriWIpNFB9/QrTTld2hCgSBmRFd/0zcM2cI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)