UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'j3HgRS5F84QbTiFdx1qr7AS2a7y42W0giLuqvAFUkl4='
WHERE
key_id = '6bfc5c67d61e92fd2c1f9766d6665b28963c4307edba199cff87b7b19e5b6be8'
AND (
token = 'j3HgRS5F84QbTiFdx1qr7AS2a7y42W0giLuqvAFUkl4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)