UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vFpEq2VgaZsPwS4z4I2G1ingtQETfFkpu23e4ari2qU='
WHERE
key_id = '3de96c504b109bca3f719f64a5ae2cf91fe3781a0c9edb0c43136302fab2eb56'
AND (
token = 'vFpEq2VgaZsPwS4z4I2G1ingtQETfFkpu23e4ari2qU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)