UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pYd2TSoPYt8OBHWh7Cp8A3fhIPVZ2Bltc810SyyuVHE='
WHERE
key_id = '8cd5d7c9489382f0bd404f4a7f8d10d87b6cd50c76788be6d00f61237a41b12d'
AND (
token = 'pYd2TSoPYt8OBHWh7Cp8A3fhIPVZ2Bltc810SyyuVHE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)