UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tM1sG9ZDn4VmxnAhdsSJgg6g/Su9hoZ8cgFyjCZlqf0='
WHERE
key_id = 'fca718de084636ce7c8d305e3bcec83d695fc717449f975ffd6d75cb4dbcf1e7'
AND (
token = 'tM1sG9ZDn4VmxnAhdsSJgg6g/Su9hoZ8cgFyjCZlqf0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)