UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'u65lThISjpBpoUTpg+TcDXRi5uZShDOrZsq5Yz+lvvU='
WHERE
key_id = 'c8fc2860c2b87e1a344e79783c22f5ec6a27fa55d0f9f50a2c5f9a738863f20a'
AND (
token = 'u65lThISjpBpoUTpg+TcDXRi5uZShDOrZsq5Yz+lvvU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)