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