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