UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rwnRVJ5baT5Bu/V8SLvf0ts/J10KTTndUIkLd4qhdLs='
WHERE
key_id = 'f7b6655d4fd482a306addf8a71a4581c9df5b917536b50fc9c7cc90e10dca76b'
AND (
token = 'rwnRVJ5baT5Bu/V8SLvf0ts/J10KTTndUIkLd4qhdLs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)