UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0Pk78FJkEEl5oYOC8azGFKUETM5lV1XUW4TVSsee0Hs='
WHERE
key_id = 'b8a6c9aaa9b537bf564d4aade996bd845fcf3610ef474d7852f725d22d04c930'
AND (
token = '0Pk78FJkEEl5oYOC8azGFKUETM5lV1XUW4TVSsee0Hs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)