UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C7c7kenj9Dl+uSXIaGxNxSOKoYW3w8I7m6Di71UrlYw='
WHERE
key_id = 'fab9ebe57348569833386321a9c6a7697c9ca7756b19e91915e062c338bf8b09'
AND (
token = 'C7c7kenj9Dl+uSXIaGxNxSOKoYW3w8I7m6Di71UrlYw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)