UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BFqnEpVjoAjfaody9kW/zXuirT2FLiLU6C2CZ588cms='
WHERE
key_id = 'f29a339b10612947e5a0ff23bbe9d35ad9a99ee90655563c0cd96e50dcc16241'
AND (
token = 'BFqnEpVjoAjfaody9kW/zXuirT2FLiLU6C2CZ588cms='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)