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