UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tWXQmnH9i/wTluE6341vnDFICABpySgrN3CavZkoYQo='
WHERE
key_id = '96c3786bbc4a3b4f42ac04085107557bf6a4bb446551dfaa217880b47b046551'
AND (
token = 'tWXQmnH9i/wTluE6341vnDFICABpySgrN3CavZkoYQo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)