UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd1p5bml0uSo53yH6qSIUD+Tirc8npC1iX6wAGzNyzUg='
WHERE
key_id = '58fb87b3d8a8005ebdd4d8fc606654348e245708d8f117e8aeca5650f64bed0d'
AND (
token = 'd1p5bml0uSo53yH6qSIUD+Tirc8npC1iX6wAGzNyzUg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)