UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3w/jObf3d4abohuplfcttafztD3HEWPRnwHfRWRpAkY='
WHERE
key_id = 'f8af7697e808a73885f6fea229b9d5b375ab7a4d18b98e1d3555bcfc24f892c8'
AND (
token = '3w/jObf3d4abohuplfcttafztD3HEWPRnwHfRWRpAkY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)