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