UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OvD8rvXS9vc8LGMXfJjToOemkqCdIcNwIlLsK565dgg='
WHERE
key_id = 'fed8c16108a816055ede368aeeeff742a46804c3aa6e2b5d505ea2a68e7c2a2e'
AND (
token = 'OvD8rvXS9vc8LGMXfJjToOemkqCdIcNwIlLsK565dgg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)