UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hE7SaEMj976OQw0pn6+j3pAY3SktZVmdmyJiJwV/3xo='
WHERE
key_id = '5d2172a3a0e5d376ba87408c7aa3764ca88d6751abd3e626aebabb6e75468c5a'
AND (
token = 'hE7SaEMj976OQw0pn6+j3pAY3SktZVmdmyJiJwV/3xo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)