UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8QnCwLaBSA0DdVt/cEO/5dS4Dia5jiEbmxYmBvqHfN4='
WHERE
key_id = '52120287c282bf52107aec9994106bd1ac60f3b4ec4fc6873ab64bd7c42a489b'
AND (
token = '8QnCwLaBSA0DdVt/cEO/5dS4Dia5jiEbmxYmBvqHfN4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)