UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7J8vZWeg9aDN1PeTEgS/hStuak3euKck7jRpdvafGWA='
WHERE
key_id = '429292fac8bc42408663cd303286eb31298ee9ef4878078d7bbf063ad21ecc91'
AND (
token = '7J8vZWeg9aDN1PeTEgS/hStuak3euKck7jRpdvafGWA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)