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